отчёт по последней загрузке и инвентаризации
Набросал вот простой отчёт по последней загрузке системы, авторизировавшемуся пользователю и инвентаризации.
SELECT DISTINCT
dbo.v_R_System.Name0 AS [PC name], dbo.v_GS_OPERATING_SYSTEM.Caption0 AS [Operation System],
dbo.v_GS_OPERATING_SYSTEM.CSDVersion0 AS [Service pack], dbo.v_GS_COMPUTER_SYSTEM.UserName0 AS [Last logon user],
dbo.v_GS_WORKSTATION_STATUS.LastHWScan AS [Last hardware inventory], dbo.v_GS_OPERATING_SYSTEM.LastBootUpTime0 AS [Last bootup time]
FROM dbo.v_R_System INNER JOIN
dbo.v_GS_COMPUTER_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_COMPUTER_SYSTEM.ResourceID INNER JOIN
dbo.v_GS_WORKSTATION_STATUS ON dbo.v_R_System.ResourceID = dbo.v_GS_WORKSTATION_STATUS.ResourceID INNER JOIN
dbo.v_GS_OPERATING_SYSTEM ON dbo.v_R_System.ResourceID = dbo.v_GS_OPERATING_SYSTEM.ResourceID
